transactional summary

Dataset statistics

Number of variables	29
Number of observations	786363
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.0 GiB
Average record size in memory	1.4 KiB

Variable types

Numeric	9
Categorical	17
Boolean	3

Warnings

`echoBuffer` has constant value ""	Constant
`merchantCity` has constant value ""	Constant
`merchantState` has constant value ""	Constant
`merchantZip` has constant value ""	Constant
`posOnPremises` has constant value ""	Constant
`recurringAuthInd` has constant value ""	Constant
`transactionDateTime` has a high cardinality: 776637 distinct values	High cardinality
`merchantName` has a high cardinality: 2490 distinct values	High cardinality
`currentExpDate` has a high cardinality: 165 distinct values	High cardinality
`accountOpenDate` has a high cardinality: 1820 distinct values	High cardinality
`dateOfLastAddressChange` has a high cardinality: 2184 distinct values	High cardinality
`transactionDateTime` is uniformly distributed	Uniform
`transactionAmount` has 22225 (2.8%) zeros	Zeros
`currentBalance` has 33678 (4.3%) zeros	Zeros

Reproduction

Analysis started	2021-03-01 23:44:21.222040
Analysis finished	2021-03-02 00:12:52.485329
Duration	28 minutes and 31.26 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

accountNumber
Real number (ℝ_≥0)

Distinct	5000
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	537232599.5
Minimum	100088067
Maximum	999389635
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	100088067
5-th percentile	151258718
Q1	330133277
median	507456073
Q3	767620004
95-th percentile	948004238
Maximum	999389635
Range	899301568
Interquartile range (IQR)	437486727

Descriptive statistics

Standard deviation	255421092.3
Coefficient of variation (CV)	0.4754385578
Kurtosis	-1.21865435
Mean	537232599.5
Median Absolute Deviation (MAD)	218237767
Skewness	0.1124155098
Sum	4.224598386 × 10¹⁴
Variance	6.52399344 × 10¹⁶
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
380680241	32850	4.2%
882815134	13189	1.7%
570884863	10867	1.4%
246251253	10172	1.3%
369308035	7229	0.9%
724518977	6283	0.8%
894938833	6101	0.8%
419709514	5930	0.8%
832842201	5850	0.7%
208319653	5235	0.7%
Other values (4990)	682657	86.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100088067	75	< 0.1%
100108752	18	< 0.1%
100328049	103	< 0.1%
100663626	31	< 0.1%
100737756	178	< 0.1%
100947057	8	< 0.1%
101132326	68	< 0.1%
101339369	37	< 0.1%
101376441	65	< 0.1%
101380713	120	< 0.1%

Value	Count	Frequency (%)
999389635	9	< 0.1%
999283629	141	< 0.1%
999258704	88	< 0.1%
999257059	160	< 0.1%
999086814	677	0.1%
998869994	8	< 0.1%
998801944	237	< 0.1%
998771329	39	< 0.1%
998706877	8	< 0.1%
998272908	295	< 0.1%

customerId
Real number (ℝ_≥0)

Distinct	5000
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	537232599.5
Minimum	100088067
Maximum	999389635
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	100088067
5-th percentile	151258718
Q1	330133277
median	507456073
Q3	767620004
95-th percentile	948004238
Maximum	999389635
Range	899301568
Interquartile range (IQR)	437486727

Descriptive statistics

Standard deviation	255421092.3
Coefficient of variation (CV)	0.4754385578
Kurtosis	-1.21865435
Mean	537232599.5
Median Absolute Deviation (MAD)	218237767
Skewness	0.1124155098
Sum	4.224598386 × 10¹⁴
Variance	6.52399344 × 10¹⁶
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
380680241	32850	4.2%
882815134	13189	1.7%
570884863	10867	1.4%
246251253	10172	1.3%
369308035	7229	0.9%
724518977	6283	0.8%
894938833	6101	0.8%
419709514	5930	0.8%
832842201	5850	0.7%
208319653	5235	0.7%
Other values (4990)	682657	86.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100088067	75	< 0.1%
100108752	18	< 0.1%
100328049	103	< 0.1%
100663626	31	< 0.1%
100737756	178	< 0.1%
100947057	8	< 0.1%
101132326	68	< 0.1%
101339369	37	< 0.1%
101376441	65	< 0.1%
101380713	120	< 0.1%

Value	Count	Frequency (%)
999389635	9	< 0.1%
999283629	141	< 0.1%
999258704	88	< 0.1%
999257059	160	< 0.1%
999086814	677	0.1%
998869994	8	< 0.1%
998801944	237	< 0.1%
998771329	39	< 0.1%
998706877	8	< 0.1%
998272908	295	< 0.1%

creditLimit
Real number (ℝ_≥0)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10759.46446
Minimum	250
Maximum	50000
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	250
5-th percentile	500
Q1	5000
median	7500
Q3	15000
95-th percentile	50000
Maximum	50000
Range	49750
Interquartile range (IQR)	10000

Descriptive statistics

Standard deviation	11636.17489
Coefficient of variation (CV)	1.08148272
Kurtosis	5.173764693
Mean	10759.46446
Median Absolute Deviation (MAD)	5000
Skewness	2.280312163
Sum	8460844750
Variance	135400566.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5000	201863	25.7%
15000	139307	17.7%
7500	97913	12.5%
2500	75429	9.6%
20000	68629	8.7%
10000	56889	7.2%
50000	48781	6.2%
1000	36430	4.6%
250	34025	4.3%
500	27097	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
250	34025	4.3%
500	27097	3.4%
1000	36430	4.6%
2500	75429	9.6%
5000	201863	25.7%
7500	97913	12.5%
10000	56889	7.2%
15000	139307	17.7%
20000	68629	8.7%
50000	48781	6.2%

Value	Count	Frequency (%)
50000	48781	6.2%
20000	68629	8.7%
15000	139307	17.7%
10000	56889	7.2%
7500	97913	12.5%
5000	201863	25.7%
2500	75429	9.6%
1000	36430	4.6%
500	27097	3.4%
250	34025	4.3%

availableMoney
Real number (ℝ)

Distinct	521916
Distinct (%)	66.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6250.725369
Minimum	-1005.63
Maximum	50000
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	-1005.63
5-th percentile	178.67
Q1	1077.42
median	3184.86
Q3	7500
95-th percentile	19911.672
Maximum	50000
Range	51005.63
Interquartile range (IQR)	6422.58

Descriptive statistics

Standard deviation	8880.783989
Coefficient of variation (CV)	1.420760546
Kurtosis	10.27296495
Mean	6250.725369
Median Absolute Deviation (MAD)	2524.42
Skewness	2.999323595
Sum	4915339154
Variance	78868324.26
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
250	6015	0.8%
5000	5400	0.7%
15000	4254	0.5%
7500	4069	0.5%
500	2811	0.4%
2500	2809	0.4%
10000	2757	0.4%
20000	2496	0.3%
1000	1865	0.2%
50000	1207	0.2%
Other values (521906)	752680	95.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1005.63	1	< 0.1%
-972.12	1	< 0.1%
-936.08	1	< 0.1%
-930.55	1	< 0.1%
-916.03	1	< 0.1%
-909.53	1	< 0.1%
-882.69	1	< 0.1%
-877.79	1	< 0.1%
-853.41	1	< 0.1%
-851.31	1	< 0.1%

Value	Count	Frequency (%)
50000	1207	0.2%
49999.72	1	< 0.1%
49999.62	1	< 0.1%
49999.43	1	< 0.1%
49998.89	1	< 0.1%
49998.83	1	< 0.1%
49998.82	1	< 0.1%
49998.35	1	< 0.1%
49998.21	1	< 0.1%
49998.07	1	< 0.1%

transactionDateTime
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	776637
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Memory size	57.0 MiB

2016-12-25T14:04:15	4
2016-05-28T14:24:41	4
2016-04-16T23:45:39	3
2016-05-11T04:22:40	3
2016-02-25T17:00:11	3
Other values (776632)	786346

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	14940897
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	766989 ?
Unique (%)	97.5%

Sample

1st row	2016-08-13T14:27:32
2nd row	2016-10-11T05:05:54
3rd row	2016-11-08T09:18:39
4th row	2016-12-10T02:14:50
5th row	2016-03-24T21:04:46

Value	Count	Frequency (%)
2016-12-25T14:04:15	4	< 0.1%
2016-05-28T14:24:41	4	< 0.1%
2016-04-16T23:45:39	3	< 0.1%
2016-05-11T04:22:40	3	< 0.1%
2016-02-25T17:00:11	3	< 0.1%
2016-11-19T12:58:00	3	< 0.1%
2016-02-26T19:57:50	3	< 0.1%
2016-09-27T07:48:42	3	< 0.1%
2016-02-21T23:29:36	3	< 0.1%
2016-12-09T05:00:38	3	< 0.1%
Other values (776627)	786331	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
2016-05-28t14:24:41	4	< 0.1%
2016-12-25t14:04:15	4	< 0.1%
2016-12-23t12:09:17	3	< 0.1%
2016-10-13t06:33:05	3	< 0.1%
2016-08-11t02:23:06	3	< 0.1%
2016-06-20t20:39:36	3	< 0.1%
2016-04-06t18:26:24	3	< 0.1%
2016-12-09t05:00:38	3	< 0.1%
2016-06-02t11:27:00	3	< 0.1%
2016-10-27t05:25:55	3	< 0.1%
Other values (776627)	786331	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	2588303	17.3%
1	2316631	15.5%
2	1900367	12.7%
-	1572726	10.5%
:	1572726	10.5%
6	1150941	7.7%
T	786363	5.3%
3	695491	4.7%
5	628805	4.2%
4	623835	4.2%
Other values (3)	1104709	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11009082	73.7%
Dash Punctuation	1572726	10.5%
Other Punctuation	1572726	10.5%
Uppercase Letter	786363	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	2588303	23.5%
1	2316631	21.0%
2	1900367	17.3%
6	1150941	10.5%
3	695491	6.3%
5	628805	5.7%
4	623835	5.7%
8	369100	3.4%
7	368189	3.3%
9	367420	3.3%

Value	Count	Frequency (%)
-	1572726	100.0%

Value	Count	Frequency (%)
T	786363	100.0%

Value	Count	Frequency (%)
:	1572726	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	14154534	94.7%
Latin	786363	5.3%

Most frequent character per script

Value	Count	Frequency (%)
0	2588303	18.3%
1	2316631	16.4%
2	1900367	13.4%
-	1572726	11.1%
:	1572726	11.1%
6	1150941	8.1%
3	695491	4.9%
5	628805	4.4%
4	623835	4.4%
8	369100	2.6%
Other values (2)	735609	5.2%

Value	Count	Frequency (%)
T	786363	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14940897	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	2588303	17.3%
1	2316631	15.5%
2	1900367	12.7%
-	1572726	10.5%
:	1572726	10.5%
6	1150941	7.7%
T	786363	5.3%
3	695491	4.7%
5	628805	4.2%
4	623835	4.2%
Other values (3)	1104709	7.4%

transactionAmount
Real number (ℝ_≥0)

ZEROS

Distinct	66038
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	136.985791
Minimum	0
Maximum	2011.54
Zeros	22225
Zeros (%)	2.8%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	3.44
Q1	33.65
median	87.9
Q3	191.48
95-th percentile	433.35
Maximum	2011.54
Range	2011.54
Interquartile range (IQR)	157.83

Descriptive statistics

Standard deviation	147.725569
Coefficient of variation (CV)	1.078400672
Kurtosis	6.446378027
Mean	136.985791
Median Absolute Deviation (MAD)	66.44
Skewness	2.092246265
Sum	107720557.5
Variance	21822.84374
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22225	2.8%
8.21	132	< 0.1%
49.3	125	< 0.1%
8.81	124	< 0.1%
4.39	120	< 0.1%
7.53	119	< 0.1%
8.22	117	< 0.1%
4.69	115	< 0.1%
8.04	112	< 0.1%
8.7	111	< 0.1%
Other values (66028)	763063	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22225	2.8%
0.01	60	< 0.1%
0.02	56	< 0.1%
0.03	32	< 0.1%
0.04	56	< 0.1%
0.05	43	< 0.1%
0.06	43	< 0.1%
0.07	56	< 0.1%
0.08	50	< 0.1%
0.09	38	< 0.1%

Value	Count	Frequency (%)
2011.54	1	< 0.1%
1905.3	1	< 0.1%
1873.97	1	< 0.1%
1780.6	1	< 0.1%
1772.63	1	< 0.1%
1767.5	1	< 0.1%
1710.13	1	< 0.1%
1707.8	1	< 0.1%
1704.55	1	< 0.1%
1693.36	1	< 0.1%

merchantName
Categorical

HIGH CARDINALITY

Distinct	2490
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	53.3 MiB

Uber	25613
Lyft	25523
oldnavy.com	16992
staples.com	16980
alibaba.com	16959
Other values (2485)	684296

Length

Max length	30
Median length	13
Mean length	14.13677526
Min length	4

Characters and Unicode

Total characters	11116637
Distinct characters	64
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Uber
2nd row	AMC #191138
3rd row	Play Store
4th row	Play Store
5th row	Tim Hortons #947751

Value	Count	Frequency (%)
Uber	25613	3.3%
Lyft	25523	3.2%
oldnavy.com	16992	2.2%
staples.com	16980	2.2%
alibaba.com	16959	2.2%
apple.com	16898	2.1%
walmart.com	16873	2.1%
cheapfast.com	16858	2.1%
ebay.com	16842	2.1%
target.com	16813	2.1%
Other values (2480)	600012	76.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
putt	61424	3.8%
amc	37942	2.3%
ecards	33072	2.0%
ez	30922	1.9%
services	27996	1.7%
fresh	26224	1.6%
uber	25613	1.6%
lyft	25523	1.6%
online	24832	1.5%
gas	23910	1.5%
Other values (2541)	1318851	80.6%

Most occurring characters

Value	Count	Frequency (%)
	849946	7.6%
e	718185	6.5%
a	653772	5.9%
s	537605	4.8%
o	535320	4.8%
t	516495	4.6%
n	462311	4.2%
i	377087	3.4%
r	343496	3.1%
c	338300	3.0%
Other values (54)	5784120	52.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6435319	57.9%
Decimal Number	1973023	17.7%
Uppercase Letter	1256921	11.3%
Space Separator	849946	7.6%
Other Punctuation	588811	5.3%
Dash Punctuation	12617	0.1%

Most frequent character per category

Value	Count	Frequency (%)
S	125613	10.0%
C	116700	9.3%
P	109916	8.7%
A	93360	7.4%
M	90446	7.2%
B	86290	6.9%
F	72510	5.8%
D	72228	5.7%
R	50488	4.0%
H	47930	3.8%
Other values (15)	391440	31.1%

Value	Count	Frequency (%)
e	718185	11.2%
a	653772	10.2%
s	537605	8.4%
o	535320	8.3%
t	516495	8.0%
n	462311	7.2%
i	377087	5.9%
r	343496	5.3%
c	338300	5.3%
l	305047	4.7%
Other values (14)	1647701	25.6%

Value	Count	Frequency (%)
1	223145	11.3%
4	214795	10.9%
2	213836	10.8%
3	204038	10.3%
9	202519	10.3%
6	200498	10.2%
8	193623	9.8%
5	190057	9.6%
7	173770	8.8%
0	156742	7.9%

Value	Count	Frequency (%)
#	332018	56.4%
.	213742	36.3%
'	43051	7.3%

Value	Count	Frequency (%)
	849946	100.0%

Value	Count	Frequency (%)
-	12617	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7692240	69.2%
Common	3424397	30.8%

Most frequent character per script

Value	Count	Frequency (%)
e	718185	9.3%
a	653772	8.5%
s	537605	7.0%
o	535320	7.0%
t	516495	6.7%
n	462311	6.0%
i	377087	4.9%
r	343496	4.5%
c	338300	4.4%
l	305047	4.0%
Other values (39)	2904622	37.8%

Value	Count	Frequency (%)
	849946	24.8%
#	332018	9.7%
1	223145	6.5%
4	214795	6.3%
2	213836	6.2%
.	213742	6.2%
3	204038	6.0%
9	202519	5.9%
6	200498	5.9%
8	193623	5.7%
Other values (5)	576237	16.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11116637	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	849946	7.6%
e	718185	6.5%
a	653772	5.9%
s	537605	4.8%
o	535320	4.8%
t	516495	4.6%
n	462311	4.2%
i	377087	3.4%
r	343496	3.1%
c	338300	3.0%
Other values (54)	5784120	52.0%

acqCountry
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	44.2 MiB

US	774709
	4562
MEX	3130
CAN	2424
PR	1538

Length

Max length	3
Median length	2
Mean length	1.995460112
Min length	0

Characters and Unicode

Total characters	1569156
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US
2nd row	US
3rd row	US
4th row	US
5th row	US

Value	Count	Frequency (%)
US	774709	98.5%
	4562	0.6%
MEX	3130	0.4%
CAN	2424	0.3%
PR	1538	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
us	774709	99.1%
mex	3130	0.4%
can	2424	0.3%
pr	1538	0.2%

Most occurring characters

Value	Count	Frequency (%)
U	774709	49.4%
S	774709	49.4%
M	3130	0.2%
E	3130	0.2%
X	3130	0.2%
C	2424	0.2%
A	2424	0.2%
N	2424	0.2%
P	1538	0.1%
R	1538	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1569156	100.0%

Most frequent character per category

Value	Count	Frequency (%)
U	774709	49.4%
S	774709	49.4%
M	3130	0.2%
E	3130	0.2%
X	3130	0.2%
C	2424	0.2%
A	2424	0.2%
N	2424	0.2%
P	1538	0.1%
R	1538	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1569156	100.0%

Most frequent character per script

Value	Count	Frequency (%)
U	774709	49.4%
S	774709	49.4%
M	3130	0.2%
E	3130	0.2%
X	3130	0.2%
C	2424	0.2%
A	2424	0.2%
N	2424	0.2%
P	1538	0.1%
R	1538	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1569156	100.0%

Most frequent character per block

Value	Count	Frequency (%)
U	774709	49.4%
S	774709	49.4%
M	3130	0.2%
E	3130	0.2%
X	3130	0.2%
C	2424	0.2%
A	2424	0.2%
N	2424	0.2%
P	1538	0.1%
R	1538	0.1%

merchantCountryCode
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	44.3 MiB

US	778511
MEX	3143
CAN	2426
PR	1559
	724

Length

Max length	3
Median length	2
Mean length	2.005240582
Min length	0

Characters and Unicode

Total characters	1576847
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US
2nd row	US
3rd row	US
4th row	US
5th row	US

Value	Count	Frequency (%)
US	778511	99.0%
MEX	3143	0.4%
CAN	2426	0.3%
PR	1559	0.2%
	724	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
us	778511	99.1%
mex	3143	0.4%
can	2426	0.3%
pr	1559	0.2%

Most occurring characters

Value	Count	Frequency (%)
U	778511	49.4%
S	778511	49.4%
M	3143	0.2%
E	3143	0.2%
X	3143	0.2%
C	2426	0.2%
A	2426	0.2%
N	2426	0.2%
P	1559	0.1%
R	1559	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1576847	100.0%

Most frequent character per category

Value	Count	Frequency (%)
U	778511	49.4%
S	778511	49.4%
M	3143	0.2%
E	3143	0.2%
X	3143	0.2%
C	2426	0.2%
A	2426	0.2%
N	2426	0.2%
P	1559	0.1%
R	1559	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1576847	100.0%

Most frequent character per script

Value	Count	Frequency (%)
U	778511	49.4%
S	778511	49.4%
M	3143	0.2%
E	3143	0.2%
X	3143	0.2%
C	2426	0.2%
A	2426	0.2%
N	2426	0.2%
P	1559	0.1%
R	1559	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1576847	100.0%

Most frequent character per block

Value	Count	Frequency (%)
U	778511	49.4%
S	778511	49.4%
M	3143	0.2%
E	3143	0.2%
X	3143	0.2%
C	2426	0.2%
A	2426	0.2%
N	2426	0.2%
P	1559	0.1%
R	1559	0.1%

posEntryMode
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	44.2 MiB

05	315035
09	236481
02	195934
90	19576
80	15283

Length

Max length	2
Median length	2
Mean length	1.98968924
Min length	0

Characters and Unicode

Total characters	1564618
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	02
2nd row	09
3rd row	09
4th row	09
5th row	02

Value	Count	Frequency (%)
05	315035	40.1%
09	236481	30.1%
02	195934	24.9%
90	19576	2.5%
80	15283	1.9%
	4054	0.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
05	315035	40.3%
09	236481	30.2%
02	195934	25.0%
90	19576	2.5%
80	15283	2.0%

Most occurring characters

Value	Count	Frequency (%)
0	782309	50.0%
5	315035	20.1%
9	256057	16.4%
2	195934	12.5%
8	15283	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1564618	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	782309	50.0%
5	315035	20.1%
9	256057	16.4%
2	195934	12.5%
8	15283	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1564618	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	782309	50.0%
5	315035	20.1%
9	256057	16.4%
2	195934	12.5%
8	15283	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1564618	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	782309	50.0%
5	315035	20.1%
9	256057	16.4%
2	195934	12.5%
8	15283	1.0%

posConditionCode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	44.2 MiB

01	628787
08	149634
99	7533
	409

Length

Max length	2
Median length	2
Mean length	1.998959768
Min length	0

Characters and Unicode

Total characters	1571908
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	01
2nd row	01
3rd row	01
4th row	01
5th row	01

Value	Count	Frequency (%)
01	628787	80.0%
08	149634	19.0%
99	7533	1.0%
	409	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
01	628787	80.0%
08	149634	19.0%
99	7533	1.0%

Most occurring characters

Value	Count	Frequency (%)
0	778421	49.5%
1	628787	40.0%
8	149634	9.5%
9	15066	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1571908	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	778421	49.5%
1	628787	40.0%
8	149634	9.5%
9	15066	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1571908	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	778421	49.5%
1	628787	40.0%
8	149634	9.5%
9	15066	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1571908	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	778421	49.5%
1	628787	40.0%
8	149634	9.5%
9	15066	1.0%

merchantCategoryCode
Categorical

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	50.2 MiB

online_retail	202156
fastfood	112138
entertainment	80098
food	75490
online_gifts	66238
Other values (14)	250243

Length

Max length	20
Median length	12
Mean length	9.93804388
Min length	3

Characters and Unicode

Total characters	7814910
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	rideshare
2nd row	entertainment
3rd row	mobileapps
4th row	mobileapps
5th row	fastfood

Value	Count	Frequency (%)
online_retail	202156	25.7%
fastfood	112138	14.3%
entertainment	80098	10.2%
food	75490	9.6%
online_gifts	66238	8.4%
rideshare	51136	6.5%
hotels	34097	4.3%
fuel	23910	3.0%
subscriptions	22901	2.9%
auto	21651	2.8%
Other values (9)	96548	12.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
online_retail	202156	25.1%
fastfood	112138	13.9%
entertainment	80098	9.9%
food	75490	9.4%
online_gifts	66238	8.2%
rideshare	51136	6.3%
hotels	34097	4.2%
fuel	23910	3.0%
subscriptions	22901	2.8%
auto	21651	2.7%
Other values (10)	115512	14.3%

Most occurring characters

Value	Count	Frequency (%)
e	991808	12.7%
n	876374	11.2%
i	806271	10.3%
o	791769	10.1%
t	737066	9.4%
l	615464	7.9%
a	555983	7.1%
r	492698	6.3%
f	403346	5.2%
s	399467	5.1%
Other values (13)	1144664	14.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7509103	96.1%
Connector Punctuation	285461	3.7%
Space Separator	18964	0.2%
Other Punctuation	1382	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	991808	13.2%
n	876374	11.7%
i	806271	10.7%
o	791769	10.5%
t	737066	9.8%
l	615464	8.2%
a	555983	7.4%
r	492698	6.6%
f	403346	5.4%
s	399467	5.3%
Other values (10)	838857	11.2%

Value	Count	Frequency (%)
_	285461	100.0%

Value	Count	Frequency (%)
	18964	100.0%

Value	Count	Frequency (%)
/	1382	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7509103	96.1%
Common	305807	3.9%

Most frequent character per script

Value	Count	Frequency (%)
e	991808	13.2%
n	876374	11.7%
i	806271	10.7%
o	791769	10.5%
t	737066	9.8%
l	615464	8.2%
a	555983	7.4%
r	492698	6.6%
f	403346	5.4%
s	399467	5.3%
Other values (10)	838857	11.2%

Value	Count	Frequency (%)
_	285461	93.3%
	18964	6.2%
/	1382	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7814910	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	991808	12.7%
n	876374	11.2%
i	806271	10.3%
o	791769	10.1%
t	737066	9.4%
l	615464	7.9%
a	555983	7.1%
r	492698	6.3%
f	403346	5.2%
s	399467	5.1%
Other values (13)	1144664	14.6%

currentExpDate
Categorical

HIGH CARDINALITY

Distinct	165
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.0 MiB

03/2029	5103
08/2024	5087
10/2023	5075
05/2027	5063
01/2021	5041
Other values (160)	760994

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	5504541
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	06/2023
2nd row	02/2024
3rd row	08/2025
4th row	08/2025
5th row	10/2029

Value	Count	Frequency (%)
03/2029	5103	0.6%
08/2024	5087	0.6%
10/2023	5075	0.6%
05/2027	5063	0.6%
01/2021	5041	0.6%
10/2032	5039	0.6%
08/2030	5029	0.6%
08/2022	5026	0.6%
07/2031	5022	0.6%
05/2026	5021	0.6%
Other values (155)	735857	93.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
03/2029	5103	0.6%
08/2024	5087	0.6%
10/2023	5075	0.6%
05/2027	5063	0.6%
01/2021	5041	0.6%
10/2032	5039	0.6%
08/2030	5029	0.6%
08/2022	5026	0.6%
07/2031	5022	0.6%
05/2026	5021	0.6%
Other values (155)	735857	93.6%

Most occurring characters

Value	Count	Frequency (%)
2	1605016	29.2%
0	1558893	28.3%
/	786363	14.3%
1	441079	8.0%
3	368935	6.7%
7	125901	2.3%
5	125315	2.3%
6	124091	2.3%
8	123490	2.2%
4	123283	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4718178	85.7%
Other Punctuation	786363	14.3%

Most frequent character per category

Value	Count	Frequency (%)
2	1605016	34.0%
0	1558893	33.0%
1	441079	9.3%
3	368935	7.8%
7	125901	2.7%
5	125315	2.7%
6	124091	2.6%
8	123490	2.6%
4	123283	2.6%
9	122175	2.6%

Value	Count	Frequency (%)
/	786363	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5504541	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	1605016	29.2%
0	1558893	28.3%
/	786363	14.3%
1	441079	8.0%
3	368935	6.7%
7	125901	2.3%
5	125315	2.3%
6	124091	2.3%
8	123490	2.2%
4	123283	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5504541	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	1605016	29.2%
0	1558893	28.3%
/	786363	14.3%
1	441079	8.0%
3	368935	6.7%
7	125901	2.3%
5	125315	2.3%
6	124091	2.3%
8	123490	2.2%
4	123283	2.2%

accountOpenDate
Categorical

HIGH CARDINALITY

Distinct	1820
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	50.2 MiB

2014-06-21	33623
2014-09-30	13335
2014-05-22	11353
2012-10-09	10867
2014-10-02	10653
Other values (1815)	706532

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	7863630
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	2015-03-14
2nd row	2015-03-14
3rd row	2015-03-14
4th row	2015-03-14
5th row	2015-08-06

Value	Count	Frequency (%)
2014-06-21	33623	4.3%
2014-09-30	13335	1.7%
2014-05-22	11353	1.4%
2012-10-09	10867	1.4%
2014-10-02	10653	1.4%
2014-11-05	6693	0.9%
2014-12-04	6584	0.8%
2015-03-01	5962	0.8%
2015-02-21	5881	0.7%
2015-08-14	5503	0.7%
Other values (1810)	675909	86.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-06-21	33623	4.3%
2014-09-30	13335	1.7%
2014-05-22	11353	1.4%
2012-10-09	10867	1.4%
2014-10-02	10653	1.4%
2014-11-05	6693	0.9%
2014-12-04	6584	0.8%
2015-03-01	5962	0.8%
2015-02-21	5881	0.7%
2015-08-14	5503	0.7%
Other values (1810)	675909	86.0%

Most occurring characters

Value	Count	Frequency (%)
0	1791694	22.8%
-	1572726	20.0%
1	1491726	19.0%
2	1339947	17.0%
5	425469	5.4%
4	381282	4.8%
3	264152	3.4%
9	178943	2.3%
6	158049	2.0%
7	131384	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6290904	80.0%
Dash Punctuation	1572726	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	1791694	28.5%
1	1491726	23.7%
2	1339947	21.3%
5	425469	6.8%
4	381282	6.1%
3	264152	4.2%
9	178943	2.8%
6	158049	2.5%
7	131384	2.1%
8	128258	2.0%

Value	Count	Frequency (%)
-	1572726	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7863630	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	1791694	22.8%
-	1572726	20.0%
1	1491726	19.0%
2	1339947	17.0%
5	425469	5.4%
4	381282	4.8%
3	264152	3.4%
9	178943	2.3%
6	158049	2.0%
7	131384	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7863630	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	1791694	22.8%
-	1572726	20.0%
1	1491726	19.0%
2	1339947	17.0%
5	425469	5.4%
4	381282	4.8%
3	264152	3.4%
9	178943	2.3%
6	158049	2.0%
7	131384	1.7%

dateOfLastAddressChange
Categorical

HIGH CARDINALITY

Distinct	2184
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	50.2 MiB

2016-03-15	3819
2016-01-06	3740
2016-01-04	3558
2016-06-08	3355
2016-04-04	3194
Other values (2179)	768697

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	7863630
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	2015-03-14
2nd row	2015-03-14
3rd row	2015-03-14
4th row	2015-03-14
5th row	2015-08-06

Value	Count	Frequency (%)
2016-03-15	3819	0.5%
2016-01-06	3740	0.5%
2016-01-04	3558	0.5%
2016-06-08	3355	0.4%
2016-04-04	3194	0.4%
2016-02-22	3102	0.4%
2016-03-23	3091	0.4%
2016-04-07	3036	0.4%
2016-05-19	2969	0.4%
2016-01-01	2925	0.4%
Other values (2174)	753574	95.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
2016-03-15	3819	0.5%
2016-01-06	3740	0.5%
2016-01-04	3558	0.5%
2016-06-08	3355	0.4%
2016-04-04	3194	0.4%
2016-02-22	3102	0.4%
2016-03-23	3091	0.4%
2016-04-07	3036	0.4%
2016-05-19	2969	0.4%
2016-01-01	2925	0.4%
Other values (2174)	753574	95.8%

Most occurring characters

Value	Count	Frequency (%)
0	1795546	22.8%
-	1572726	20.0%
1	1449902	18.4%
2	1258981	16.0%
6	557064	7.1%
5	299459	3.8%
4	243269	3.1%
3	235552	3.0%
9	157186	2.0%
7	147127	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6290904	80.0%
Dash Punctuation	1572726	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	1795546	28.5%
1	1449902	23.0%
2	1258981	20.0%
6	557064	8.9%
5	299459	4.8%
4	243269	3.9%
3	235552	3.7%
9	157186	2.5%
7	147127	2.3%
8	146818	2.3%

Value	Count	Frequency (%)
-	1572726	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7863630	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	1795546	22.8%
-	1572726	20.0%
1	1449902	18.4%
2	1258981	16.0%
6	557064	7.1%
5	299459	3.8%
4	243269	3.1%
3	235552	3.0%
9	157186	2.0%
7	147127	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7863630	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	1795546	22.8%
-	1572726	20.0%
1	1449902	18.4%
2	1258981	16.0%
6	557064	7.1%
5	299459	3.8%
4	243269	3.1%
3	235552	3.0%
9	157186	2.0%
7	147127	1.9%

cardCVV
Real number (ℝ_≥0)

Distinct	899
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	544.4673376
Minimum	100
Maximum	998
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 MiB

Quantile statistics

Minimum	100
5-th percentile	141
Q1	310
median	535
Q3	785
95-th percentile	948
Maximum	998
Range	898
Interquartile range (IQR)	475

Descriptive statistics

Standard deviation	261.5242203
Coefficient of variation (CV)	0.4803304114
Kurtosis	-1.248157188
Mean	544.4673376
Median Absolute Deviation (MAD)	236
Skewness	0.046386637
Sum	428148969
Variance	68394.91778
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
869	33749	4.3%
289	15509	2.0%
640	10804	1.4%
455	10279	1.3%
959	7024	0.9%
917	6503	0.8%
548	5487	0.7%
586	5245	0.7%
296	5125	0.7%
494	5038	0.6%
Other values (889)	681600	86.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100	192	< 0.1%
101	1000	0.1%
102	136	< 0.1%
103	224	< 0.1%
104	1303	0.2%
105	380	< 0.1%
106	129	< 0.1%
107	1179	0.1%
108	3978	0.5%
109	258	< 0.1%

Value	Count	Frequency (%)
998	850	0.1%
997	314	< 0.1%
996	2294	0.3%
995	961	0.1%
994	118	< 0.1%
993	152	< 0.1%
992	785	0.1%
991	261	< 0.1%
990	348	< 0.1%
989	1038	0.1%

enteredCVV
Real number (ℝ_≥0)

Distinct	976
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	544.1838566
Minimum	0
Maximum	998
Zeros	8
Zeros (%)	< 0.1%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	141
Q1	310
median	535
Q3	785
95-th percentile	948
Maximum	998
Range	998
Interquartile range (IQR)	475

Descriptive statistics

Standard deviation	261.5512537
Coefficient of variation (CV)	0.4806303063
Kurtosis	-1.246938755
Mean	544.1838566
Median Absolute Deviation (MAD)	236
Skewness	0.04621024635
Sum	427926050
Variance	68409.0583
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
869	33424	4.3%
289	15401	2.0%
640	10731	1.4%
455	10176	1.3%
959	6963	0.9%
917	6440	0.8%
548	5438	0.7%
586	5202	0.7%
296	5081	0.6%
494	5005	0.6%
Other values (966)	682502	86.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	< 0.1%
1	1	< 0.1%
3	6	< 0.1%
4	1	< 0.1%
5	2	< 0.1%
6	1	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
9	4	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
998	846	0.1%
997	316	< 0.1%
996	2262	0.3%
995	950	0.1%
994	119	< 0.1%
993	154	< 0.1%
992	784	0.1%
991	263	< 0.1%
990	349	< 0.1%
989	1036	0.1%

cardLast4Digits
Real number (ℝ_≥0)

Distinct	5245
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4757.417799
Minimum	0
Maximum	9998
Zeros	5578
Zeros (%)	0.7%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	482
Q1	2178
median	4733
Q3	7338
95-th percentile	9522
Maximum	9998
Range	9998
Interquartile range (IQR)	5160

Descriptive statistics

Standard deviation	2996.58381
Coefficient of variation (CV)	0.6298761085
Kurtosis	-1.277451616
Mean	4757.417799
Median Absolute Deviation (MAD)	2569
Skewness	0.07904789115
Sum	3741057333
Variance	8979514.53
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
593	32946	4.2%
2194	10867	1.4%
6002	10172	1.3%
6580	6747	0.9%
8502	6553	0.8%
2178	5930	0.8%
0	5578	0.7%
7629	5235	0.7%
2701	4826	0.6%
2864	4533	0.6%
Other values (5235)	692976	88.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5578	0.7%
1	23	< 0.1%
2	495	0.1%
3	71	< 0.1%
4	11	< 0.1%
7	15	< 0.1%
8	22	< 0.1%
13	437	0.1%
14	428	0.1%
16	235	< 0.1%

Value	Count	Frequency (%)
9998	31	< 0.1%
9997	44	< 0.1%
9996	111	< 0.1%
9994	62	< 0.1%
9993	9	< 0.1%
9990	93	< 0.1%
9989	15	< 0.1%
9988	123	< 0.1%
9987	4	< 0.1%
9986	15	< 0.1%

transactionType
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.0 MiB

PURCHASE	745193
REVERSAL	20303
ADDRESS_VERIFICATION	20169
	698

Length

Max length	20
Median length	8
Mean length	8.300680475
Min length	0

Characters and Unicode

Total characters	6527348
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PURCHASE
2nd row	PURCHASE
3rd row	PURCHASE
4th row	PURCHASE
5th row	PURCHASE

Value	Count	Frequency (%)
PURCHASE	745193	94.8%
REVERSAL	20303	2.6%
ADDRESS_VERIFICATION	20169	2.6%
	698	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
purchase	745193	94.8%
reversal	20303	2.6%
address_verification	20169	2.6%

Most occurring characters

Value	Count	Frequency (%)
R	826137	12.7%
E	826137	12.7%
A	805834	12.3%
S	805834	12.3%
C	765362	11.7%
P	745193	11.4%
U	745193	11.4%
H	745193	11.4%
I	60507	0.9%
V	40472	0.6%
Other values (7)	161486	2.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6507179	99.7%
Connector Punctuation	20169	0.3%

Most frequent character per category

Value	Count	Frequency (%)
R	826137	12.7%
E	826137	12.7%
A	805834	12.4%
S	805834	12.4%
C	765362	11.8%
P	745193	11.5%
U	745193	11.5%
H	745193	11.5%
I	60507	0.9%
V	40472	0.6%
Other values (6)	141317	2.2%

Value	Count	Frequency (%)
_	20169	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6507179	99.7%
Common	20169	0.3%

Most frequent character per script

Value	Count	Frequency (%)
R	826137	12.7%
E	826137	12.7%
A	805834	12.4%
S	805834	12.4%
C	765362	11.8%
P	745193	11.5%
U	745193	11.5%
H	745193	11.5%
I	60507	0.9%
V	40472	0.6%
Other values (6)	141317	2.2%

Value	Count	Frequency (%)
_	20169	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6527348	100.0%

Most frequent character per block

Value	Count	Frequency (%)
R	826137	12.7%
E	826137	12.7%
A	805834	12.3%
S	805834	12.3%
C	765362	11.7%
P	745193	11.4%
U	745193	11.4%
H	745193	11.4%
I	60507	0.9%
V	40472	0.6%
Other values (7)	161486	2.5%

echoBuffer
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	42.7 MiB

	786363

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	786363	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

currentBalance
Real number (ℝ_≥0)

ZEROS

Distinct	487318
Distinct (%)	62.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4508.739089
Minimum	0
Maximum	47498.81
Zeros	33678
Zeros (%)	4.3%
Memory size	6.0 MiB

Quantile statistics

Minimum	0
5-th percentile	15.74
Q1	689.91
median	2451.76
Q3	5291.095
95-th percentile	14600.382
Maximum	47498.81
Range	47498.81
Interquartile range (IQR)	4601.185

Descriptive statistics

Standard deviation	6457.442068
Coefficient of variation (CV)	1.432205754
Kurtosis	14.61307813
Mean	4508.739089
Median Absolute Deviation (MAD)	2010.45
Skewness	3.362136708
Sum	3545505596
Variance	41698558.06
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33678	4.3%
8.46	26	< 0.1%
29.42	19	< 0.1%
5.67	19	< 0.1%
59.68	18	< 0.1%
18.86	17	< 0.1%
10.04	17	< 0.1%
116.69	17	< 0.1%
3.58	16	< 0.1%
55.04	16	< 0.1%
Other values (487308)	752520	95.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33678	4.3%
0.01	2	< 0.1%
0.02	5	< 0.1%
0.03	4	< 0.1%
0.04	4	< 0.1%
0.05	1	< 0.1%
0.06	5	< 0.1%
0.07	2	< 0.1%
0.08	1	< 0.1%
0.09	1	< 0.1%

Value	Count	Frequency (%)
47498.81	1	< 0.1%
47496.84	1	< 0.1%
47496.32	1	< 0.1%
47493.83	1	< 0.1%
47493.74	1	< 0.1%
47493.26	1	< 0.1%
47492.24	1	< 0.1%
47491.22	1	< 0.1%
47489.5	1	< 0.1%
47489	1	< 0.1%

merchantCity
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	42.7 MiB

	786363

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	786363	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

merchantState
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	42.7 MiB

	786363

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	786363	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

merchantZip
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	42.7 MiB

	786363

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	786363	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

cardPresent
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	768.1 KiB

False	433495
True	352868

Common Values
Chart

Value	Count	Frequency (%)
False	433495	55.1%
True	352868	44.9%

posOnPremises
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	42.7 MiB

	786363

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	786363	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

recurringAuthInd
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	42.7 MiB

	786363

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	786363	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
No values found.

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

expirationDateKeyInMatch
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	768.1 KiB

False	785320
True	1043

Common Values
Chart

Value	Count	Frequency (%)
False	785320	99.9%
True	1043	0.1%

isFraud
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	768.1 KiB

False	773946
True	12417

Common Values
Chart

Value	Count	Frequency (%)
False	773946	98.4%
True	12417	1.6%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	accountNumber	customerId	creditLimit	availableMoney	transactionDateTime	transactionAmount	merchantName	acqCountry	merchantCountryCode	posEntryMode	posConditionCode	merchantCategoryCode	currentExpDate	accountOpenDate	dateOfLastAddressChange	cardCVV	enteredCVV	cardLast4Digits	transactionType	currentBalance	cardPresent	expirationDateKeyInMatch	isFraud
0	737265056	737265056	5000.0	5000.00	2016-08-13T14:27:32	98.55	Uber	US	US	02	01	rideshare	06/2023	2015-03-14	2015-03-14	414	414	1803	PURCHASE	0.00	False	False	False
1	737265056	737265056	5000.0	5000.00	2016-10-11T05:05:54	74.51	AMC #191138	US	US	09	01	entertainment	02/2024	2015-03-14	2015-03-14	486	486	767	PURCHASE	0.00	True	False	False
2	737265056	737265056	5000.0	5000.00	2016-11-08T09:18:39	7.47	Play Store	US	US	09	01	mobileapps	08/2025	2015-03-14	2015-03-14	486	486	767	PURCHASE	0.00	False	False	False
3	737265056	737265056	5000.0	5000.00	2016-12-10T02:14:50	7.47	Play Store	US	US	09	01	mobileapps	08/2025	2015-03-14	2015-03-14	486	486	767	PURCHASE	0.00	False	False	False
4	830329091	830329091	5000.0	5000.00	2016-03-24T21:04:46	71.18	Tim Hortons #947751	US	US	02	01	fastfood	10/2029	2015-08-06	2015-08-06	885	885	3143	PURCHASE	0.00	True	False	False
5	830329091	830329091	5000.0	5000.00	2016-04-19T16:24:27	30.76	In-N-Out #422833	US	US	02	01	fastfood	01/2020	2015-08-06	2015-08-06	885	885	3143	PURCHASE	0.00	True	False	False
6	830329091	830329091	5000.0	5000.00	2016-05-21T14:50:35	57.28	Krispy Kreme #685312	US	US	02	01	fastfood	05/2020	2015-08-06	2015-08-06	885	885	3143	PURCHASE	0.00	True	False	False
7	830329091	830329091	5000.0	5000.00	2016-06-03T00:31:21	9.37	Shake Shack #968081	US	US	05	01	fastfood	01/2021	2015-08-06	2015-08-06	885	885	3143	PURCHASE	0.00	True	False	False
8	830329091	830329091	5000.0	4990.63	2016-06-10T01:21:46	523.67	Burger King #486122		US	02	01	fastfood	08/2032	2015-08-06	2015-08-06	885	885	3143	PURCHASE	9.37	True	False	False
9	830329091	830329091	5000.0	5000.00	2016-07-11T10:47:16	164.37	Five Guys #510989	US	US	05	08	fastfood	04/2020	2015-08-06	2015-08-06	885	885	3143	PURCHASE	0.00	True	False	False

Last rows

	accountNumber	customerId	creditLimit	availableMoney	transactionDateTime	transactionAmount	merchantName	acqCountry	merchantCountryCode	posEntryMode	posConditionCode	merchantCategoryCode	currentExpDate	accountOpenDate	dateOfLastAddressChange	cardCVV	enteredCVV	cardLast4Digits	transactionType	currentBalance	cardPresent	expirationDateKeyInMatch	isFraud
786353	732852505	732852505	50000.0	49796.87	2016-12-10T12:24:38	190.41	EZ Putt Putt #804489	US	US	09	01	entertainment	06/2029	2012-08-23	2012-08-23	936	936	3783	PURCHASE	203.13	True	False	False
786354	732852505	732852505	50000.0	49606.46	2016-12-10T23:29:11	83.97	KFC #206511	US	US	05	08	fastfood	12/2030	2012-08-23	2012-08-23	939	939	3388	PURCHASE	393.54	True	False	False
786355	732852505	732852505	50000.0	49522.49	2016-12-18T14:06:34	157.22	Uber	US	US	09	01	rideshare	08/2029	2012-08-23	2012-08-23	936	936	3783	PURCHASE	477.51	False	False	False
786356	732852505	732852505	50000.0	49365.27	2016-12-19T03:25:53	408.83	Lyft	US	US	09	01	rideshare	06/2021	2012-08-23	2012-08-23	939	939	3388	PURCHASE	634.73	False	False	False
786357	732852505	732852505	50000.0	48956.44	2016-12-22T07:27:23	51.48	Sunoco Gas #380975	US	US	05	08	fuel	07/2032	2012-08-23	2012-08-23	936	936	3783	PURCHASE	1043.56	True	False	False
786358	732852505	732852505	50000.0	48904.96	2016-12-22T18:44:12	119.92	Lyft	US	US	90	01	rideshare	12/2022	2012-08-23	2012-08-23	936	936	3783	PURCHASE	1095.04	False	False	False
786359	732852505	732852505	50000.0	48785.04	2016-12-25T16:20:34	18.89	hulu.com	US	US	09	01	online_subscriptions	08/2023	2012-08-23	2012-08-23	939	939	3388	PURCHASE	1214.96	False	False	False
786360	732852505	732852505	50000.0	48766.15	2016-12-27T15:46:24	49.43	Lyft	US	US	02	01	rideshare	08/2025	2012-08-23	2012-08-23	936	936	3783	PURCHASE	1233.85	False	False	False
786361	732852505	732852505	50000.0	48716.72	2016-12-29T00:30:55	49.89	walmart.com	US	US	09	99	online_retail	07/2022	2012-08-23	2012-08-23	939	939	3388	PURCHASE	1283.28	False	False	False
786362	732852505	732852505	50000.0	48666.83	2016-12-30T20:10:29	72.18	Uber	US	US	05	01	rideshare	05/2024	2012-08-23	2012-08-23	939	939	3388	PURCHASE	1333.17	False	False	False

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters